﻿<%@ Page Title="" Language="C#" MasterPageFile="~/UserSystem/Employee/Shop.master" AutoEventWireup="true" CodeFile="ListItem.aspx.cs" Inherits="ListItem" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <div class="Content">
        <br /><h1>All item available on system</h1>
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataSourceID="SqlDataSourceList" ForeColor="#333333" 
            GridLines="None" Width="577px" DataKeyNames="I_ID">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="I_ID" HeaderText="Number" 
                    SortExpression="I_ID" InsertVisible="False" ReadOnly="True" />
                <asp:BoundField DataField="Cat_Name" HeaderText="Categories" 
                    SortExpression="Cat_Name" />
                <asp:BoundField DataField="I_Name" HeaderText="Item" 
                    SortExpression="I_Name" />
                <asp:HyperLinkField Text="Details" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceList" runat="server" 
            ConnectionString="Data Source=TRUNGPHAMDU84B6;Initial Catalog=stationery;User ID=sa;Password=12345678" 
            
            SelectCommand="select Item.I_ID, Categories.Cat_Name, Item.I_Name from Item Inner Join Categories on Item.Cat_ID = Categories.Cat_ID ">
        </asp:SqlDataSource>
    </div>
</asp:Content>

